﻿# SQL Manager Lite for MySQL 5.3.1.7
# ---------------------------------------
# Host     : localhost
# Port     : 3306
# Database : flx_qcubed


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

SET FOREIGN_KEY_CHECKS=0;

USE flx_qcubed;

#
# Data for the project table  (LIMIT -484,500)
#

INSERT INTO project (id, name, date, is_enable, description, log_user, log_insert, log_update) VALUES

  (1,'Lorem Ipsum','2013-11-28 00:00:00',1,'Lorem ipsum dolor sit amet, consectetur adipiscing elit. In tristique purus a felis vulputate varius. Phasellus congue egestas pharetra. Suspendisse eu sollicitudin quam. Nam sagittis ligula mi. In quis quam justo. Sed malesuada felis id leo pulvinar, nec','jmirancid','2013-08-09 09:13:13','2013-11-28 09:04:49'),
  (4,'Suspendisse potenti','2013-09-07 00:00:00',1,'Suspendisse rhoncus orci nulla, at viverra dui pharetra id. Phasellus bibendum sapien id neque sollicitudin, eu fringilla libero gravida.',NULL,NULL,'2013-09-07 12:29:29'),
  (5,'Pellentesque eleifend.','2013-07-17 00:00:00',1,'Praesent ac blandit odio. Sed lorem enim, ullamcorper vitae sagittis nec, ullamcorper vel eros.',NULL,NULL,'2013-09-07 12:30:31'),
  (6,'Vestibulum molestie.','2013-06-26 00:00:00',1,'Vivamus vitae condimentum velit, sit amet eleifend justo.',NULL,NULL,'2013-09-07 12:32:23'),
  (7,'Praesent ut ullamcorper risus.','2013-05-14 00:00:00',1,'Etiam imperdiet leo eu quam sagittis, eu suscipit odio ornare. Curabitur eu condimentum neque.',NULL,NULL,'2013-09-07 12:33:28'),
  (8,'Donec eu magna quis','2013-07-31 00:00:00',1,'Suspendisse malesuada dolor non nibh dictum, at molestie dolor feugiat. Phasellus porta quam magna.','jmirancid',NULL,'2013-12-17 09:00:30'),
  (10,'Cras sollicitudin felis augue.','2013-05-22 00:00:00',1,'Proin commodo ornare odio, ac volutpat dui. In vitae enim feugiat lorem scelerisque vestibulum at quis turpis.',NULL,NULL,'2013-09-07 12:38:46'),
  (11,'Cras euismod imperdiet est sed vestibulum.','2013-05-27 00:00:00',1,'Fusce nulla tortor, condimentum non venenatis a, ultrices id leo. Nullam adipiscing viverra risus eget aliquam.',NULL,NULL,'2013-09-07 12:41:22'),
  (12,'Nullam lorem ligula.','2013-09-08 00:00:00',1,'Nam ipsum metus, ullamcorper a velit et, gravida pharetra diam. Mauris lorem odio, cursus porta risus in, ullamcorper egestas ligula.',NULL,NULL,'2013-09-07 12:44:27'),
  (13,'Suspendisse pretium massa.','2013-08-14 00:00:00',1,'Pellentesque mi arcu, lacinia non sem a, aliquam sollicitudin leo. Aliquam venenatis velit ut sapien bibendum sagittis.',NULL,NULL,'2013-09-07 12:51:52'),
  (14,'Maecenas at sapien nisi.','2013-08-01 00:00:00',1,'Nullam lorem ligula, elementum non metus eu, euismod posuere dolor.',NULL,NULL,'2013-09-07 12:52:41'),
  (15,'Proin eget mauris ligula.','2013-05-22 00:00:00',1,'Mauris lobortis nisl porta neque laoreet, et iaculis sem auctor. Ut in laoreet eros.',NULL,NULL,'2013-09-07 12:53:25'),
  (16,'Proin at massa turpis.','2013-04-16 00:00:00',1,'Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Etiam at consectetur eros, et consequat lectus.',NULL,NULL,'2013-09-07 12:54:08'),
  (17,'Pellentesque vel mi lorem.','2013-02-11 00:00:00',1,'Suspendisse malesuada dolor non nibh dictum, at molestie dolor feugiat. Phasellus porta quam magna.',NULL,NULL,'2013-09-07 12:56:28'),
  (19,'Sed ut luctus metus.','2013-05-02 00:00:00',1,'Etiam a faucibus dui, non lacinia tortor. Donec tempor libero eu nunc tincidunt, eget vulputate turpis mattis.',NULL,NULL,'2013-09-07 12:57:11');
COMMIT;

#
# Data for the project_gallery table  (LIMIT -493,500)
#

INSERT INTO project_gallery (id, project_id, description, internal, url, secure_url, thumb_url, width, height, format, size, log_user, log_insert, log_update) VALUES

  (22,1,'Sillon sin terminar.','bd4ahyw32yhft3dyezzq','http://res.cloudinary.com/dl05ea4pe/image/upload/v1381152409/bd4ahyw32yhft3dyezzq.jpg','https://res.cloudinary.com/dl05ea4pe/image/upload/v1381152409/bd4ahyw32yhft3dyezzq.jpg','http://res.cloudinary.com/dl05ea4pe/image/upload/c_thumb,h_180,w_260,q_60/bd4ahyw32yhft3dyezzq.jpg',719,540,'jpg',61706,'jmirancid','2013-10-07 06:26:50','2013-11-06 21:39:55'),
  (23,1,'Modelo Terminado.','ndwdp5m3hbqppozpetdy','http://res.cloudinary.com/dl05ea4pe/image/upload/v1381209410/ndwdp5m3hbqppozpetdy.jpg','https://res.cloudinary.com/dl05ea4pe/image/upload/v1381209410/ndwdp5m3hbqppozpetdy.jpg','http://res.cloudinary.com/dl05ea4pe/image/upload/c_thumb,h_180,w_260,q_60/ndwdp5m3hbqppozpetdy.jpg',719,540,'jpg',74872,'jmirancid','2013-10-07 22:16:51','2013-11-06 21:39:41'),
  (24,4,'Sillas','r5htlpptgqilzlojl37l','http://res.cloudinary.com/dl05ea4pe/image/upload/v1381411632/r5htlpptgqilzlojl37l.jpg','https://res.cloudinary.com/dl05ea4pe/image/upload/v1381411632/r5htlpptgqilzlojl37l.jpg','http://res.cloudinary.com/dl05ea4pe/image/upload/c_thumb,h_180,q_60,w_260/v1381411632/r5htlpptgqilzlojl37l.jpg',539,720,'jpg',75424,'jmirancid','2013-10-10 06:27:13','2013-11-06 21:39:30'),
  (25,1,'Testing images','n2ubnkcnzbjpn6e8ts3g','http://res.cloudinary.com/dl05ea4pe/image/upload/v1383791900/n2ubnkcnzbjpn6e8ts3g.jpg','https://res.cloudinary.com/dl05ea4pe/image/upload/v1383791900/n2ubnkcnzbjpn6e8ts3g.jpg','http://res.cloudinary.com/dl05ea4pe/image/upload/c_thumb,h_180,q_60,w_260/n2ubnkcnzbjpn6e8ts3g.jpg',539,720,'jpg',69982,'jmirancid','2013-11-06 18:38:20','2013-11-06 23:38:20'),
  (27,4,'Silla derecha','idouo4pgv5pif0q1rkdv','http://res.cloudinary.com/dl05ea4pe/image/upload/v1385040868/idouo4pgv5pif0q1rkdv.jpg','https://res.cloudinary.com/dl05ea4pe/image/upload/v1385040868/idouo4pgv5pif0q1rkdv.jpg','http://res.cloudinary.com/dl05ea4pe/image/upload/c_thumb,h_180,q_60,w_260/idouo4pgv5pif0q1rkdv.jpg',404,540,'jpg',42298,'jmirancid','2013-11-21 05:34:28','2013-11-21 10:34:28'),
  (30,1,'Sillita','tv0avwpp35sqghlf2vmd','http://res.cloudinary.com/dl05ea4pe/image/upload/v1385732750/tv0avwpp35sqghlf2vmd.jpg','https://res.cloudinary.com/dl05ea4pe/image/upload/v1385732750/tv0avwpp35sqghlf2vmd.jpg','http://res.cloudinary.com/dl05ea4pe/image/upload/c_thumb,h_180,q_60,w_260/tv0avwpp35sqghlf2vmd.jpg',539,720,'jpg',79785,'jmirancid','2013-11-29 05:45:50','2013-11-29 10:45:50');
COMMIT;

#
# Data for the project_service table  (LIMIT -455,500)
#

INSERT INTO project_service (project_id, service_id, log_user, log_insert, log_update) VALUES

  (1,1,'jmirancid','2013-08-09 09:13:13','2013-12-17 09:00:22'),
  (1,2,'jmirancid','2013-08-09 09:13:13','2013-12-17 09:00:22'),
  (1,3,'jmirancid','2013-08-09 09:13:13','2013-12-17 09:00:22'),
  (4,3,NULL,NULL,'2013-09-07 12:29:29'),
  (4,4,NULL,NULL,'2013-09-07 12:29:29'),
  (4,6,NULL,NULL,'2013-09-07 12:29:29'),
  (5,3,NULL,NULL,'2013-09-07 12:30:31'),
  (5,4,NULL,NULL,'2013-09-07 12:30:31'),
  (5,5,NULL,NULL,'2013-09-07 12:30:31'),
  (6,5,NULL,NULL,'2013-09-07 12:32:23'),
  (6,6,NULL,NULL,'2013-09-07 12:32:23'),
  (7,1,NULL,NULL,'2013-09-07 12:33:28'),
  (7,2,NULL,NULL,'2013-09-07 12:33:28'),
  (7,3,NULL,NULL,'2013-09-07 12:33:28'),
  (7,4,NULL,NULL,'2013-09-07 12:33:28'),
  (7,5,NULL,NULL,'2013-09-07 12:33:28'),
  (7,6,NULL,NULL,'2013-09-07 12:33:28'),
  (8,1,'jmirancid',NULL,'2013-12-17 09:00:30'),
  (8,2,'jmirancid',NULL,'2013-12-17 09:00:30'),
  (8,3,'jmirancid',NULL,'2013-12-17 09:00:30'),
  (8,4,'jmirancid',NULL,'2013-12-17 09:00:30'),
  (10,3,NULL,NULL,'2013-09-07 12:38:46'),
  (10,4,NULL,NULL,'2013-09-07 12:38:46'),
  (10,5,NULL,NULL,'2013-09-07 12:38:46'),
  (11,3,NULL,NULL,'2013-09-07 12:41:22'),
  (11,4,NULL,NULL,'2013-09-07 12:41:22'),
  (12,1,NULL,NULL,'2013-09-07 12:44:27'),
  (12,2,NULL,NULL,'2013-09-07 12:44:27'),
  (12,3,NULL,NULL,'2013-09-07 12:44:27'),
  (12,4,NULL,NULL,'2013-09-07 12:44:27'),
  (12,5,NULL,NULL,'2013-09-07 12:44:27'),
  (12,6,NULL,NULL,'2013-09-07 12:44:27'),
  (13,1,NULL,NULL,'2013-09-07 12:51:52'),
  (13,3,NULL,NULL,'2013-09-07 12:51:52'),
  (13,4,NULL,NULL,'2013-09-07 12:51:52'),
  (14,2,NULL,NULL,'2013-09-07 12:52:41'),
  (14,6,NULL,NULL,'2013-09-07 12:52:41'),
  (15,5,NULL,NULL,'2013-09-07 12:53:25'),
  (16,5,NULL,NULL,'2013-09-07 12:54:08'),
  (16,6,NULL,NULL,'2013-09-07 12:54:08'),
  (17,1,NULL,NULL,'2013-09-07 12:56:28'),
  (17,2,NULL,NULL,'2013-09-07 12:56:28'),
  (19,4,NULL,NULL,'2013-09-07 12:57:11'),
  (19,5,NULL,NULL,'2013-09-07 12:57:11');
COMMIT;

#
# Data for the service table  (LIMIT -493,500)
#

INSERT INTO service (id, name, description, is_enable, order, log_user, log_insert, log_update) VALUES

  (1,'Laqueado','Trabajo realizado en cabina con distintos procesos para lograr un acabado perfecto del mobiliario. Este sistema permite un tipo de lustre que resiste al uso diario y prolonga la vida útil del mismo por mucho más tiempo que cualquier lustre común.',1,1,'jmirancid',NULL,'2013-12-14 12:20:40'),
  (2,'Lustre','Se <b>acondicina el mobiliario</b> se rasquetea segÃºn necesidades del mismo, se lija y se lustra a muÃ±eca hasta lograr el acabado deseado.',1,2,'jmirancid',NULL,'2014-05-13 21:44:58'),
  (3,'Gomalaca','<p>Lustre realizado con productos importados de India se realiza todo en forma manual, es un trabajo artesanal.</p>',1,3,'jmirancid',NULL,'2013-11-21 07:17:31'),
  (4,'Restauraciones','Se repara el mobiliario y se crean piezas faltantes de ser necesario, conservando e incluso incrementando su valor en el mercado con lustre y reacondicionamiento.',1,4,NULL,NULL,'2013-08-23 10:24:15'),
  (5,'Amoblamientos a Medida','Pueden realizarse en madera y tambien en melamina. DiseÃ±o y estilos segÃºn gustos del cliente, brindamos asesoramiento en cuanto al diseÃ±o del mismo, estilos y tendencias que esten acordes al ambiente a intervenir.',1,5,NULL,NULL,'2013-08-23 10:08:31'),
  (6,'Tapiceria','Este trabajo se realiza sobre todo tipo de sillones y sillas el mismo se realiza en forma artesanal ya que se destapizan en forma total para corroborar la estructura, se verifican los elasticos, goma, liensillo, etc. se elige tela segÃºn gusto del cliente y se restaura en forma total logrando excelentes resultados.',1,6,NULL,NULL,'2013-08-23 10:23:45');
COMMIT;

#
# Data for the setting table  (LIMIT -483,500)
#

INSERT INTO setting (id, key, value, description, log_user, log_insert, log_update) VALUES

  (1,'email_server_name','ssl://smtp.gmail.com','Email Server Hostname','_init','0000-00-00 00:00:00','2013-10-08 01:45:17'),
  (2,'email_server_port','465','Email Server Port','_init','0000-00-00 00:00:00','2013-10-08 01:45:18'),
  (3,'email_server_user','nortatum@gmail.com','Email Server Account Username','_init','0000-00-00 00:00:00','2013-10-08 01:45:19'),
  (4,'email_server_pass','Pa$$word001','Email Server Account Password','_init','0000-00-00 00:00:00','2013-10-08 01:45:19'),
  (5,'email_server_test','c:/temp/','Email Server Test Queue Path','_init','0000-00-00 00:00:00','2013-10-08 01:45:20'),
  (6,'cloudinary_cloudname','dl05ea4pe','Cloudinary Storage Service Cloud Name','_init','0000-00-00 00:00:00','2013-10-08 01:45:20'),
  (7,'cloudinary_api_key','645385234334422','Cloudinary Storage Service API Key','_init','0000-00-00 00:00:00','2013-10-08 01:45:21'),
  (8,'cloudinary_secret','KkGn52w1Qc4XKwGtTtlmH1pPkt0','Cloudinary Storage Service API Secret','_init','0000-00-00 00:00:00','2013-10-08 01:45:21'),
  (9,'portrait_width','540','Portrait Image Max Width','_init','0000-00-00 00:00:00','2013-10-08 02:10:35'),
  (10,'portrait_height','720','Portrait Image Max Height','_init','0000-00-00 00:00:00','2013-10-08 02:10:37'),
  (11,'landscape_width','720','Landscape Image Max Width','_init','0000-00-00 00:00:00','2013-10-08 01:45:23'),
  (12,'landscape_height','540','Landscape Image Max Height','_init','0000-00-00 00:00:00','2013-10-08 01:45:23'),
  (13,'thumb_por_width','180','Thumbnail Portrait Image Max Width','_init','0000-00-00 00:00:00',NULL),
  (14,'thumb_por_height','260','Thumbnail Portrait Image Max Height','_init','0000-00-00 00:00:00',NULL),
  (15,'thumb_lan_width','260','Thumbnail Landscape Image Max Width','_init','0000-00-00 00:00:00',NULL),
  (16,'thumb_lan_height','180','Thumbnail Landscape Image Max Height','_init','0000-00-00 00:00:00',NULL);
COMMIT;



/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;